Access 2019 Bible by Michael Alexander & Dick Kusleika

Author:Michael Alexander & Dick Kusleika
Language: eng
Format: epub
ISBN: 9781119514749
Publisher: Wiley
Published: 2018-10-09T00:00:00+00:00

TABLE 18.4 Form Data Properties

Property Description Options

Record Source Specifies the source of data displayed on the form Unbound: Blank

Bound: The name of a table, query, or a SQL statement

Filter Used to specify a subset of records to be displayed when a filter is applied to a form; can be set in the form properties, with a macro, or through VBA Any string that is a valid SQL WHERE clause without the WHERE keyword

Filter On Load Applies filter at form/report startup Yes/No

Order By Specifies the field(s) used to order the data in the view Any string that is a valid SQL ORDER BY clause without the ORDER BY keywords

Order By On Load Applies sort at form/report startup Yes/No

Allow Filters Determines whether a user will be able to display a filtered form Yes/No

Allow Edits Determines whether a user will be able to edit data, making the form editable or read only Yes/No

Allow Deletions Determines whether a user will be able to delete records Yes/No

Allow Additions Determines whether a user will be able to add records Yes/No

Data Entry Determines whether form opens to a new blank record, not showing any saved records Yes/No

Recordset Type Used to determine whether multi‐table forms can be updated Dynaset: Only default table field controls can be edited.

Dynaset (Inconsistent Updates): All tables and fields are editable.

Snapshot: No fields are editable (same as read‐only).

Record Locks Used to determine default multiuser record locking on bound forms No Locks: Locks record only as it's saved

All Records: Locks entire form's records while using the form

Edited Record: Locks only current record during an edit

Fetch Defaults Determines whether default values should be retrieved. Yes/No

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.